Columns

Grants

Dependencies

Details

Triggers

Errors


COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT COLUMN_ID COMMENTS INSERTABLE UPDATABLE DELETABLE
OBJ VARCHAR2(20) No null 1 null NO NO NO
SH_OBJ VARCHAR2(20) No null 2 null NO NO NO
SH_DISPLAY VARCHAR2(400) Yes null 3 null NO NO NO
START_DATE DATE No null 4 null NO NO NO
END_DATE DATE Yes null 5 null NO NO NO
CODE VARCHAR2(50) No null 6 null NO NO NO
PRIVILEGE GRANTEE GRANTABLE GRANTOR OBJECT_NAME
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
QART V_ALL_INACTIVE_ACTIVITIES VIEW QART V_CURR_OBJ_OWNING_UNIT VIEW
QART V_BEHAVE_SCI_FILES VIEW QART V_CURR_OBJ_OWNING_UNIT VIEW
QART V_F_ANP VIEW QART V_CURR_OBJ_OWNING_UNIT VIEW
QART V_PERSONNEL_ASSIGNMENT_CUBE VIEW QART V_CURR_OBJ_OWNING_UNIT VIEW
QART V_CUBE_INTERCOM_ALL VIEW QART V_CURR_OBJ_OWNING_UNIT VIEW
QART V_MV_PARTICIPANT_INDIV VIEW QART V_CURR_OBJ_OWNING_UNIT VIEW
QART V_SIII_INV_ACTS VIEW QART V_CURR_OBJ_OWNING_UNIT VIEW
QART MV_SIIA_ANALYSIS MATERIALIZED VIEW QART V_CURR_OBJ_OWNING_UNIT VIEW



References


OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
QART V_CURR_OBJ_OWNING_UNIT VIEW QART MV_ACM_OBJ TABLE
QART V_CURR_OBJ_OWNING_UNIT VIEW QART MV_ACM_OBJ_TYPE TABLE
QART V_CURR_OBJ_OWNING_UNIT VIEW QART MV_ACM_STAKEHOLDER_ROLE TABLE
QART V_CURR_OBJ_OWNING_UNIT VIEW QART MV_ACM_STAKEHOLDER TABLE
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
QART V_CURR_OBJ_OWNING_UNIT VIEW QART MV_ACM_OBJ TABLE
QART V_CURR_OBJ_OWNING_UNIT VIEW QART MV_ACM_OBJ_TYPE TABLE
QART V_CURR_OBJ_OWNING_UNIT VIEW QART MV_ACM_STAKEHOLDER_ROLE TABLE
QART V_CURR_OBJ_OWNING_UNIT VIEW QART MV_ACM_STAKEHOLDER TABLE
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
QART V_CURR_OBJ_OWNING_UNIT VIEW QART MV_ACM_OBJ TABLE
QART V_CURR_OBJ_OWNING_UNIT VIEW QART MV_ACM_OBJ_TYPE TABLE
QART V_CURR_OBJ_OWNING_UNIT VIEW QART MV_ACM_STAKEHOLDER_ROLE TABLE
QART V_CURR_OBJ_OWNING_UNIT VIEW QART MV_ACM_STAKEHOLDER TABLE
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
QART V_CURR_OBJ_OWNING_UNIT VIEW QART MV_ACM_OBJ TABLE
QART V_CURR_OBJ_OWNING_UNIT VIEW QART MV_ACM_OBJ_TYPE TABLE
QART V_CURR_OBJ_OWNING_UNIT VIEW QART MV_ACM_STAKEHOLDER_ROLE TABLE
QART V_CURR_OBJ_OWNING_UNIT VIEW QART MV_ACM_STAKEHOLDER TABLE
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
QART V_CURR_OBJ_OWNING_UNIT VIEW QART MV_ACM_OBJ TABLE
QART V_CURR_OBJ_OWNING_UNIT VIEW QART MV_ACM_OBJ_TYPE TABLE
QART V_CURR_OBJ_OWNING_UNIT VIEW QART MV_ACM_STAKEHOLDER_ROLE TABLE
QART V_CURR_OBJ_OWNING_UNIT VIEW QART MV_ACM_STAKEHOLDER TABLE
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
QART V_CURR_OBJ_OWNING_UNIT VIEW QART MV_ACM_OBJ TABLE
QART V_CURR_OBJ_OWNING_UNIT VIEW QART MV_ACM_OBJ_TYPE TABLE
QART V_CURR_OBJ_OWNING_UNIT VIEW QART MV_ACM_STAKEHOLDER_ROLE TABLE
QART V_CURR_OBJ_OWNING_UNIT VIEW QART MV_ACM_STAKEHOLDER TABLE
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
QART V_CURR_OBJ_OWNING_UNIT VIEW QART MV_ACM_OBJ TABLE
QART V_CURR_OBJ_OWNING_UNIT VIEW QART MV_ACM_OBJ_TYPE TABLE
QART V_CURR_OBJ_OWNING_UNIT VIEW QART MV_ACM_STAKEHOLDER_ROLE TABLE
QART V_CURR_OBJ_OWNING_UNIT VIEW QART MV_ACM_STAKEHOLDER TABLE
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
QART V_CURR_OBJ_OWNING_UNIT VIEW QART MV_ACM_OBJ TABLE
QART V_CURR_OBJ_OWNING_UNIT VIEW QART MV_ACM_OBJ_TYPE TABLE
QART V_CURR_OBJ_OWNING_UNIT VIEW QART MV_ACM_STAKEHOLDER_ROLE TABLE
QART V_CURR_OBJ_OWNING_UNIT VIEW QART MV_ACM_STAKEHOLDER TABLE
NAME VALUE
CREATED 04-APR-23
LAST_DDL_TIME 04-APR-23
OWNER QART
VIEW_NAME V_CURR_OBJ_OWNING_UNIT
TEXT_LENGTH 780
TEXT select o.sid obj,           c_sh.stakeholder sh_obj,           cu.tagline sh_display,           c_sh.start_date,           c_sh.end_date,           c_shr.code      from mv_acm_obj o           inner join mv_acm_obj_type ot              on ot.sid = o.obj_type           inner join mv_acm_stakeholder c_sh              on     c_sh.obj = o.sid                 and (c_sh.start_date is null or c_sh.start_date <= systimestamp)                 and (c_sh.end_date is null or c_sh.end_date >= systimestamp)           inner join mv_acm_stakeholder_role c_shr              on c_shr.sid = c_sh.sh_role and c_shr.code = 'OWNING_UNIT'           inner join mv_acm_obj cu              on cu.sid = c_sh.stakeholder           inner join mv_acm_obj_type cu_ot              on cu_ot.sid = cu.obj_type
TEXT_VC select o.sid obj,           c_sh.stakeholder sh_obj,           cu.tagline sh_display,           c_sh.start_date,           c_sh.end_date,           c_shr.code      from mv_acm_obj o           inner join mv_acm_obj_type ot              on ot.sid = o.obj_type           inner join mv_acm_stakeholder c_sh              on     c_sh.obj = o.sid                 and (c_sh.start_date is null or c_sh.start_date <= systimestamp)                 and (c_sh.end_date is null or c_sh.end_date >= systimestamp)           inner join mv_acm_stakeholder_role c_shr              on c_shr.sid = c_sh.sh_role and c_shr.code = 'OWNING_UNIT'           inner join mv_acm_obj cu              on cu.sid = c_sh.stakeholder           inner join mv_acm_obj_type cu_ot              on cu_ot.sid = cu.obj_type
TYPE_TEXT_LENGTH null
TYPE_TEXT null
OID_TEXT_LENGTH null
OID_TEXT null
VIEW_TYPE_OWNER null
VIEW_TYPE null
SUPERVIEW_NAME null
EDITIONING_VIEW N
READ_ONLY N
CONTAINER_DATA N
BEQUEATH DEFINER
ORIGIN_CON_ID 16
DEFAULT_COLLATION USING_NLS_COMP
CONTAINERS_DEFAULT NO
CONTAINER_MAP NO
EXTENDED_DATA_LINK NO
EXTENDED_DATA_LINK_MAP NO
HAS_SENSITIVE_COLUMN NO
ADMIT_NULL NO
PDB_LOCAL_ONLY NO
DUPLICATED N
SHARDED N
OWNER TRIGGER_NAME TRIGGER_TYPE TRIGGERING_EVENT STATUS OBJECT_ID




ATTRIBUTE Line:Position TEXT